declare
 type parent_ty is table of
 parent%rowtype index by binary_integer;
 new_parent parent_ty;
 v_count number(4) := 20;
 begin
  for i IN 10..v_count
 loop
   select * into new_parent(i) from parent where PART_NUM =i;
   end loop;
   for i in new_parent.first..new_parent.last
  loop
   dbms_output.put_line (new_parent(i).PART_NAME);
   end loop;
  end;